Microsoft Dynamics GP Integration - Advanced Scenario - Alba Spectrum
Released on = May 15, 2006, 2:41 pm
Press Release Author = Alba Spectrum Group
Industry = Computers
Press Release Summary = Microsoft Dynamics GP 9.0 or old Microsoft Great Plains 8.0 has very solid and traditional integration tools, such as eConnect (designed for eCommerce developer), Integration Manager (this is end-user tool, with new trend to be rewritten in eConnect it is improving the performance). Also bullet proof method is direct SQL coding - SQL Stored procedure does the job in SQL Server 2005, or SQL Server 2000/7.0.
Microsoft Dynamics GP 9.0 or old Microsoft Great Plains 8.0 has very solid and traditional integration tools, such as eConnect (designed for eCommerce developer), Integration Manager (this is end-user tool, with new trend to be rewritten in eConnect it is improving the performance). Also bullet proof method is direct SQL coding - SQL Stored procedure does the job in SQL Server 2005, or SQL Server 2000/7.0. In some cases, however you need advanced integration techniques, when you involve Microsoft Dexterity engine to help you with the functionality, lacking in eConnect or Integration Manager. This technique is based on some Dexterity custom development, which in turn requires medium or advanced level of dexterity sanscript programming. . Scenario. Imagine - you create work transactions and place them into the work batch in SOP module, this could be relatively easy programmed in eConnect or through direct data insertion into SOP10100 and SOP10200 tables (document header and line). Then, if you have automatic payments from your customers through eCommerce or via EDI, these batches are good to be posted automatically with applied deposits. . Dexterity Process Server. Elegant technical solution is - use dexterity customization to track batch status and when it is ready to be posted (some custom flag). Dexterity is running on one processing workstation (without operator intervention). When flag is set - Dexterity calls its posting engine for SOP batch and "posting" in this case is not custom, but "native" and reliable, plus this type of approach doesn't require reprogramming for version upgrade
About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture of several IT and business consulting companies, now operating as single business entity. We have local presence in the Houston, Chicago, New York, Los Angeles, San Diego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, San Francisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believe in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#, VB) platforms and systems and specialize in several product lines and cross platform integration, customization, heterogeneous report design, plus we provide ERP/CRM systems comparison and reviews, not being committed to just on MRP platform. We also stake on XML cross-platform data interchange to be advanced in the coming decade.
Alba Spectrum Technologies websites: http://www.albaspectrum.com http://www.greatplains.com.mx http://www.enterlogix.com.br http://www.ronix-systems.de
2025
